home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 7 / developer source - volume 7.iso / orinf / jun96 / feuef105.gif < prev    next >
Graphics Interchange Format  |  1996-11-16  |  41KB  |  374x329  |  8-bit (213 colors)
Labels: text | screenshot | font | number | document | black and white
OCR: name The name of the procedure comes directly after the keyword FUNCTION. parameters An optional list of parameters that you define to both pass information into the procedure and send information out of the procedure, back to the calling program. return_datatype The data type of the value returned by the function. This is required in the function header and is explained in more detail below. declaration The declarations of local identifiers for that function. If you do statements not have any declarations, then there will not be any statements between the IS and BEGIN statements. executable The statements that the function executes when it is called. You statements must have at least one executable statement after the BEGIN and before the END or EXCEPTION keywords. exception The optional exception handlers for the function. If you do not handler explicitly handle any exceptions, then you can leave out the statements EXCEPTION keyword and simply terminate the execution section with the END keyword. Figure 5: The use of function components in PL/SQL